package com.gis.visualization.mapper;

import com.gis.visualization.entity.HistoryFigure;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gis.visualization.entity.vo.TimeCityVo;

import java.util.List;
import java.util.Map;
import java.util.TreeMap;


/**
 * <p>
 * 历史人物表 Mapper 接口
 * </p>
 *
 * @author hqz
 * @since 2021-02-24
 */
public interface HistoryFigureMapper extends BaseMapper<HistoryFigure> {

    List<Map<String, Object>> getAgeDistribution();

    List<TreeMap<String, Object>> getFigureCity();

    List<Map<String, Object>> getSexRatio();

    List<Map<String, Object>> getFigureTypes();

    Map<String, Object> getMinMaxYear();

    List<Map<String, Object>> getAgeDistributionByTimeCity(TimeCityVo timeCityVo);

    List<TreeMap<String, Object>> getFigureCityByTime(TimeCityVo timeCityVo);

    List<Map<String, Object>> getFigureTypesByTimeCity(TimeCityVo timeCityVo);

    List<Map<String, Object>> getSexRatioByTimeCity(TimeCityVo timeCityVo);
}
